use BAMPrimaryImport
delete from dbo.bam_AS2InterchangeActivity_Active 
delete from dbo.bam_AS2InterchangeActivity_ActiveRelationships
delete from dbo.bam_AS2InterchangeActivity_Completed
delete from dbo.bam_AS2InterchangeActivity_CompletedRelationships
delete from dbo.bam_AS2InterchangeActivity_Continuations

delete from dbo.bam_AS2MdnActivity_Active
delete from dbo.bam_AS2MdnActivity_ActiveRelationships
delete from dbo.bam_AS2MdnActivity_Completed
delete from dbo.bam_AS2MdnActivity_CompletedRelationships 
delete from dbo.bam_AS2MdnActivity_Continuations

delete from dbo.bam_BatchingActivity_Active  
delete from dbo.bam_BatchingActivity_ActiveRelationships
delete from dbo.bam_BatchingActivity_Completed
delete from dbo.bam_BatchingActivity_CompletedRelationships
delete from dbo.bam_BatchingActivity_Continuations

delete from dbo.bam_BatchInterchangeActivity_Active
delete from dbo.bam_BatchInterchangeActivity_ActiveRelationships 
delete from dbo.bam_BatchInterchangeActivity_Completed
delete from dbo.bam_BatchInterchangeActivity_CompletedRelationships
delete from dbo.bam_BatchInterchangeActivity_Continuations

delete from dbo.bam_BusinessMessageJournal_Active 
delete from dbo.bam_BusinessMessageJournal_ActiveRelationships
delete from dbo.bam_BusinessMessageJournal_Completed
delete from dbo.bam_BusinessMessageJournal_CompletedRelationships
delete from dbo.bam_BusinessMessageJournal_Continuations

delete from dbo.bam_FunctionalAckActivity_Active
delete from dbo.bam_FunctionalAckActivity_ActiveRelationships
delete from dbo.bam_FunctionalAckActivity_Completed
delete from dbo.bam_FunctionalAckActivity_CompletedRelationships
delete from dbo.bam_FunctionalAckActivity_Continuations

delete from dbo.bam_FunctionalGroupInfo_Active
delete from dbo.bam_FunctionalGroupInfo_ActiveRelationships
delete from dbo.bam_FunctionalGroupInfo_Completed
delete from dbo.bam_FunctionalGroupInfo_CompletedRelationships
delete from dbo.bam_FunctionalGroupInfo_Continuations

delete from dbo.bam_InterchangeAckActivity_Active 
delete from dbo.bam_InterchangeAckActivity_ActiveRelationships
delete from dbo.bam_InterchangeAckActivity_Completed
delete from dbo.bam_InterchangeAckActivity_CompletedRelationships
delete from dbo.bam_InterchangeAckActivity_Continuations

delete from dbo.bam_InterchangeStatusActivity_Active 
delete from dbo.bam_InterchangeStatusActivity_ActiveRelationships
delete from dbo.bam_InterchangeStatusActivity_Completed
delete from dbo.bam_InterchangeStatusActivity_CompletedRelationships
delete from dbo.bam_InterchangeStatusActivity_Continuations

delete from dbo.bam_ResendJournalActivity_Active 
delete from dbo.bam_ResendJournalActivity_Completed
delete from dbo.bam_ResendJournalActivity_CompletedRelationships
delete from dbo.bam_ResendJournalActivity_ActiveRelationships 
delete from dbo.bam_ResendJournalActivity_Continuations

delete from dbo.bam_ResendTrackingActivity_Active 
delete from dbo.bam_ResendTrackingActivity_ActiveRelationships
delete from dbo.bam_ResendTrackingActivity_Completed
delete from dbo.bam_ResendTrackingActivity_CompletedRelationships
delete from dbo.bam_ResendTrackingActivity_Continuations

delete from dbo.bam_TransactionSetActivity_Active 
delete from dbo.bam_TransactionSetActivity_ActiveRelationships 
delete from dbo.bam_TransactionSetActivity_Completed
delete from dbo.bam_TransactionSetActivity_CompletedRelationships
delete from dbo.bam_TransactionSetActivity_Continuations 
